Induced Dependencies in Relational Databases†
نویسندگان
چکیده
With the growth of database complexity and size it is becoming increasingly necessary to automate the analysis of data. Part of this automation is the development of inductive algorithms to search for characterising rules. The paper introduces the formal concept of an induced dependency as a descriptor for the relationships which characterise the data within a database. This is done within the framework of known functional dependencies held in the schema. Two distinct ways of weakening the completeness of an induction are developed, in terms of which a two dimensional matrix of types of induced dependency is defined.
منابع مشابه
Functional Dependencies in Relational Databases : A Lattice
A lattice theoretic approach is developed to study the properties of functional dependencies in relational databases. The particular attention is paid to the analysis of the semilattice of closed sets, the lattice of all closure operations on a given set and to a new characterization of normal form relation schemes. Relation schemes with restrictions on functional dependencies are also studied.
متن کاملDiscovery of Data Dependencies in Relational Databases Lss8 Report 14 Discovery of Data Dependencies in Relational Databases Lss8 Report 14
Knowledge discovery in databases is not only the nontrivial extraction of implicit, previously unknown and potentially useful information from databases. We argue that in contrast to machine learning, knowledge discovery in databases should be applied to real world databases. Since real world databases are known to be very large, they raise problems of the access. Therefore, real world database...
متن کاملDiscovery of Data Dependencies in Relational Databases
Since real world databases are known to be very large, they raise problems of the access. Therefore, real world databases onlycan be accessed by database management systems and the number of accesses has to be reduced to a minimum. Considering this property, we are forced to use standard set–oriented interfaces of relational database management systems. We present a system for discovering data ...
متن کاملFuzzy Functional Dependencies in Relational Databases
The work on this paper is an application of fuzzy set theory in relational databases. The authors introduce a new notion of fuzzy functional dependencies (ffd) in relational databases. It is observed that the existing notions of fuzzy functional dependencies (ffd) have a common drawback. Consequently the need for introducing a new type of fuzzy functional dependencies (ffd) is justified, and ex...
متن کاملWeak Functional Dependencies: Full Propositional Expressiveness for the Database Practitioner
We study inference systems of weak functional dependencies in relational and complex-value databases. Functional dependencies form a very common class of database constraints. Designers and administrators proficiently utilise them in everyday database practice. Functional dependencies correspond to the linear-time decidable fragment of Horn clauses in propositional logic. Weak functional depend...
متن کاملHorn clauses and functional dependencies in complex-value databases
We extend Fagin’s result on the equivalence between functional dependencies in relational databases and propositional Horn clauses. It is shown that this equivalence still holds for functional dependencies in databases that support complex values via nesting of records, lists, sets and multisets. The equivalence has several implications. Firstly, it extends a well-known result from relational d...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 1992